<!DOCTYPE HTML>
<html>
<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="chrome=1">
    <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no">

    

    <title>Apache Kylin安装 | 竹隐江南的博客</title>
    <meta name="author" content="dzy20@qq.com">
    
    <meta name="description" content="Apache Kylin安装">
    
    
  <meta name="viewport" content="width=device-width, initial-scale=1, maximum-scale=1">

    <meta property="og:title" content="Apache Kylin安装"/>
    <meta property="og:site_name" content="必须有人浴血奋战，世上才有自由可言！"/>

    
    <meta property="og:image" content="undefined"/>
    

    <link rel="icon" type="image/png" href="/favicon.png">
    <link rel="alternate" href="/atom.xml" title="必须有人浴血奋战，世上才有自由可言！" type="application/atom+xml">
    <link rel="stylesheet" href="/css/lib/materialize.min.css">
    <link rel="stylesheet" href="/css/lib/font-awesome.min.css">
    <link rel="stylesheet" href="/css/style.css" media="screen" type="text/css">

    
        <link rel="stylesheet" href="/css/lib/prettify-tomorrow-night-eighties.css" type="text/css">
    
    <!--[if lt IE 9]><script src="//html5shiv.googlecode.com/svn/trunk/html5.js"></script><![endif]-->
</head>


<body>
    <img src="/weixin_favicon.png" style="position: absolute; left: -9999px; opacity: 0; filter: alpha(opacity=0);">

    <nav class="green">
    <div class="nav-wrapper">
        <a href="#" data-activates="main-menu" class="button-collapse">
            <i class="fa fa-navicon"></i>
        </a>
        <div class="">
            <a href="/" class="brand-logo hide-on-med-and-down">必须有人浴血奋战，世上才有自由可言！</a>
            <ul class="right hide-on-med-and-down">
                
                    <li>
                        <a class="menu-home " href="/" >
                            <i class="fa fa-home "></i>
                            
                            首页
                        </a>
                    </li>
                
                    <li>
                        <a class="menu-archive " href="/archives" >
                            <i class="fa fa-archive "></i>
                            
                            归档
                        </a>
                    </li>
                
                    <li>
                        <a class="menu-category category-menu" href="javascript:;" data-activates="category-menu" >
                            <i class="fa fa-bookmark "></i>
                            
                            分类
                        </a>
                    </li>
                
                    <li>
                        <a class="menu-reading " href="/reading" >
                            <i class="fa fa-book "></i>
                            
                            读书
                        </a>
                    </li>
                
                    <li>
                        <a class="menu-about " href="/about" >
                            <i class="fa fa-user "></i>
                            
                            关于
                        </a>
                    </li>
                
                    <li>
                        <a class="menu-search modal-trigger " href="#search" >
                            <i class="fa fa-search "></i>
                            
                            搜索
                        </a>
                    </li>
                
            </ul>
            <div>
    <ul class="side-nav green darken-1" id="main-menu">
        
        <li class="side-user">
            <div class="row">
                <div class="col s4 no-padding">
                    <img class="avatar-image circle responsive-img" src="https://static.oschina.net/uploads/user/728/1456911_100.jpg?t=1393495702000" alt="User Avatar">
                </div>
                <div class="info col s8 valign-wrapper no-padding">
                    <div class="valign">
                        <p class="name">竹隐江南</p>
                        <p class="desc">Java后端/技术宅</p>
                    </div>
                </div>
            </div>
        </li>
        

        
            <li class="no-padding">
                <a class="waves-effect menu-home " href="/" >
                    <i class="fa fa-home "></i>
                    
                    首页
                </a>
            </li>
        
            <li class="no-padding">
                <a class="waves-effect menu-archive " href="/archives" >
                    <i class="fa fa-archive "></i>
                    
                    归档
                </a>
            </li>
        
            <li class="no-padding">
                <a class="waves-effect menu-category category-menu" href="javascript:;" data-activates="category-menu" >
                    <i class="fa fa-bookmark "></i>
                    
                    分类
                </a>
            </li>
        
            <li class="no-padding">
                <a class="waves-effect menu-reading " href="/reading" >
                    <i class="fa fa-book "></i>
                    
                    读书
                </a>
            </li>
        
            <li class="no-padding">
                <a class="waves-effect menu-about " href="/about" >
                    <i class="fa fa-user "></i>
                    
                    关于
                </a>
            </li>
        
            <li class="no-padding">
                <a class="waves-effect menu-search modal-trigger " href="#search" >
                    <i class="fa fa-search "></i>
                    
                    搜索
                </a>
            </li>
        
    </ul>

    <ul class="side-nav green darken-1" id="category-menu">
    

            

            <li class="collapse-level-0" collapse-level="0">
                <a class="no-padding" href="/categories/hive/">
                    hive <span class="right">2 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-0" collapse-level="0">
                <a class="no-padding" href="/categories/Docker/">
                    Docker <span class="right">10 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-0" collapse-level="0">
                <a class="no-padding" href="/categories/操作系统/">
                    操作系统 <span class="right">7 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-0" collapse-level="0">
                <a class="no-padding" href="/categories/系统架构/">
                    系统架构 <span class="right">2 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-0" collapse-level="0">
                <a class="no-padding" href="/categories/DevOps-CI/">
                    DevOps-CI <span class="right">1 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-0" collapse-level="0">
                <a class="no-padding" href="/categories/SSL/">
                    SSL <span class="right">1 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-0" collapse-level="0">
                <a class="no-padding" href="/categories/springboot/">
                    springboot <span class="right">8 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-0" collapse-level="0">
                <a class="no-padding" href="/categories/Linux/">
                    Linux <span class="right">1 篇</span></a>
                </a>
            </li>

        

            <li class="collapse-level-1" collapse-level="1">
                <a class="no-padding" href="/categories/Linux/Tomcat/">
                    Tomcat <span class="right">1 篇</span></a>
                </a>
            </li>

        

    </ul>
</div>

        </div>
    </div>
</nav>

<div id="search" class="modal search-modal">
    <div class="row">
        <div class="input-field col s12">
              <input id="search-input" type="text">
              <label for="search-input">搜索</label>
        </div>

    </div>
    <div id="search-result" class="search-result col s12">

    </div>
</div>


    <main>
        <div class="container main-container">
    <nav class="page-nav hide-on-small-only">
    <div class="nav-wrapper green">
        <span class="breadcrumb">当前位置（分类目录）</span>
        
            
    
    
    <a class="breadcrumb" href="/categories/hive/">hive</a>


        

        
    </div>
</nav>

<article>
    <div class="card">
        <div class="card-content">
            

            <div class="article-title">
                
    
        <h1>Apache Kylin安装</h1>
    


            </div>
            <time class="red-link-context" datetime="2017-07-06T03:16:00.000Z"><a href="/2017/07/06/Apache Kylin安装/">2017-07-06</a></time>

            <span id="busuanzi_container_page_pv" class="read-times-container">
    <i class="fa fa-eye"></i>
    <span id="busuanzi_value_page_pv"></span>
</span>

            
    <div class="tags-row">
        
            <a href="/tags/Linux/" class="chip red lighten-1">Linux</a>
        
            <a href="/tags/hadoop/" class="chip red lighten-1">hadoop</a>
        
            <a href="/tags/kylin/" class="chip red lighten-1">kylin</a>
        
    </div>


            <div class="toc red-link-context hide-on-med-and-down">
    <ol class="section table-of-contents"><li class="section table-of-contents-item section table-of-contents-level-1"><a class="section table-of-contents-link" href="#Licensed-to-the-Apache-Software-Foundation-ASF-under-one-or-more"><span class="section table-of-contents-text">Licensed to the Apache Software Foundation (ASF) under one or more</span></a></li><li class="section table-of-contents-item section table-of-contents-level-1"><a class="section table-of-contents-link" href="#contributor-license-agreements-See-the-NOTICE-file-distributed-with"><span class="section table-of-contents-text">contributor license agreements.  See the NOTICE file distributed with</span></a></li><li class="section table-of-contents-item section table-of-contents-level-1"><a class="section table-of-contents-link" href="#this-work-for-additional-information-regarding-copyright-ownership"><span class="section table-of-contents-text">this work for additional information regarding copyright ownership.</span></a></li><li class="section table-of-contents-item section table-of-contents-level-1"><a class="section table-of-contents-link" href="#The-ASF-licenses-this-file-to-You-under-the-Apache-License-Version-2-0"><span class="section table-of-contents-text">The ASF licenses this file to You under the Apache License, Version 2.0</span></a></li><li class="section table-of-contents-item section table-of-contents-level-1"><a class="section table-of-contents-link" href="#the-“License”-you-may-not-use-this-file-except-in-compliance-with"><span class="section table-of-contents-text">(the “License”); you may not use this file except in compliance with</span></a></li><li class="section table-of-contents-item section table-of-contents-level-1"><a class="section table-of-contents-link" href="#the-License-You-may-obtain-a-copy-of-the-License-at"><span class="section table-of-contents-text">the License.  You may obtain a copy of the License at</span></a></li><li class="section table-of-contents-item section table-of-contents-level-1"><a class="section table-of-contents-link" href="#http-www-apache-org-licenses-LICENSE-2-0"><span class="section table-of-contents-text">http://www.apache.org/licenses/LICENSE-2.0</span></a></li><li class="section table-of-contents-item section table-of-contents-level-1"><a class="section table-of-contents-link" href="#Unless-required-by-applicable-law-or-agreed-to-in-writing-software"><span class="section table-of-contents-text">Unless required by applicable law or agreed to in writing, software</span></a></li><li class="section table-of-contents-item section table-of-contents-level-1"><a class="section table-of-contents-link" href="#distributed-under-the-License-is-distributed-on-an-“AS-IS”-BASIS"><span class="section table-of-contents-text">distributed under the License is distributed on an “AS IS” BASIS,</span></a></li><li class="section table-of-contents-item section table-of-contents-level-1"><a class="section table-of-contents-link" href="#WITHOUT-WARRANTIES-OR-CONDITIONS-OF-ANY-KIND-either-express-or-implied"><span class="section table-of-contents-text">WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.</span></a></li><li class="section table-of-contents-item section table-of-contents-level-1"><a class="section table-of-contents-link" href="#See-the-License-for-the-specific-language-governing-permissions-and"><span class="section table-of-contents-text">See the License for the specific language governing permissions and</span></a></li><li class="section table-of-contents-item section table-of-contents-level-1"><a class="section table-of-contents-link" href="#limitations-under-the-License"><span class="section table-of-contents-text">limitations under the License.</span></a><ol class="section table-of-contents-child"><li class="section table-of-contents-item section table-of-contents-level-2"><a class="section table-of-contents-link" href="#Config-for-Kylin-Engine"><span class="section table-of-contents-text">Config for Kylin Engine</span></a></li></ol></li><li class="section table-of-contents-item section table-of-contents-level-1"><a class="section table-of-contents-link" href="#List-of-web-servers-in-use-this-enables-one-web-server-instance-to-sync-up-with-other-servers"><span class="section table-of-contents-text">List of web servers in use, this enables one web server instance to sync up with other servers.</span></a></li><li class="section table-of-contents-item section table-of-contents-level-1"><a class="section table-of-contents-link" href="#The-metadata-store-in-hbase"><span class="section table-of-contents-text">The metadata store in hbase</span></a></li><li class="section table-of-contents-item section table-of-contents-level-1"><a class="section table-of-contents-link" href="#The-storage-for-final-cube-file-in-hbase"><span class="section table-of-contents-text">The storage for final cube file in hbase</span></a></li><li class="section table-of-contents-item section table-of-contents-level-1"><a class="section table-of-contents-link" href="#Temp-folder-in-hdfs-make-sure-user-has-the-right-access-to-the-hdfs-directory"><span class="section table-of-contents-text">Temp folder in hdfs, make sure user has the right access to the hdfs directory</span></a></li><li class="section table-of-contents-item section table-of-contents-level-1"><a class="section table-of-contents-link" href="#HBase-Cluster-FileSystem-which-serving-hbase-format-as-hdfs-hbase-cluster-8020"><span class="section table-of-contents-text">HBase Cluster FileSystem, which serving hbase, format as hdfs://hbase-cluster:8020</span></a></li><li class="section table-of-contents-item section table-of-contents-level-1"><a class="section table-of-contents-link" href="#leave-empty-if-hbase-running-on-same-cluster-with-hive-and-mapreduce"><span class="section table-of-contents-text">leave empty if hbase running on same cluster with hive and mapreduce</span></a></li><li class="section table-of-contents-item section table-of-contents-level-1"><a class="section table-of-contents-link" href="#If-true-job-engine-will-not-assume-that-hadoop-CLI-reside-on-the-same-server-as-it-self"><span class="section table-of-contents-text">If true, job engine will not assume that hadoop CLI reside on the same server as it self</span></a></li><li class="section table-of-contents-item section table-of-contents-level-1"><a class="section table-of-contents-link" href="#you-will-have-to-specify-kylin-job-remote-cli-hostname-kylin-job-remote-cli-username-and-kylin-job-remote-cli-password"><span class="section table-of-contents-text">you will have to specify kylin.job.remote.cli.hostname, kylin.job.remote.cli.username and kylin.job.remote.cli.password</span></a></li><li class="section table-of-contents-item section table-of-contents-level-1"><a class="section table-of-contents-link" href="#It-should-not-be-set-to-“true”-unless-you’re-NOT-running-Kylin-sh-on-a-hadoop-client-machine"><span class="section table-of-contents-text">It should not be set to “true” unless you’re NOT running Kylin.sh on a hadoop client machine</span></a></li><li class="section table-of-contents-item section table-of-contents-level-1"><a class="section table-of-contents-link" href="#Thus-kylin-instance-has-to-ssh-to-another-real-hadoop-client-machine-to-execute-hbase-hive-hadoop-commands"><span class="section table-of-contents-text">(Thus kylin instance has to ssh to another real hadoop client machine to execute hbase,hive,hadoop commands)</span></a></li><li class="section table-of-contents-item section table-of-contents-level-1"><a class="section table-of-contents-link" href="#Only-necessary-when-kylin-job-run-as-remote-cmd-true"><span class="section table-of-contents-text">Only necessary when kylin.job.run.as.remote.cmd=true</span></a></li><li class="section table-of-contents-item section table-of-contents-level-1"><a class="section table-of-contents-link" href="#Only-necessary-when-kylin-job-run-as-remote-cmd-true-1"><span class="section table-of-contents-text">Only necessary when kylin.job.run.as.remote.cmd=true</span></a></li><li class="section table-of-contents-item section table-of-contents-level-1"><a class="section table-of-contents-link" href="#Only-necessary-when-kylin-job-run-as-remote-cmd-true-2"><span class="section table-of-contents-text">Only necessary when kylin.job.run.as.remote.cmd=true</span></a></li><li class="section table-of-contents-item section table-of-contents-level-1"><a class="section table-of-contents-link" href="#Used-by-test-cases-to-prepare-synthetic-data-for-sample-cube"><span class="section table-of-contents-text">Used by test cases to prepare synthetic data for sample cube</span></a></li><li class="section table-of-contents-item section table-of-contents-level-1"><a class="section table-of-contents-link" href="#Max-count-of-concurrent-jobs-running"><span class="section table-of-contents-text">Max count of concurrent jobs running</span></a></li><li class="section table-of-contents-item section table-of-contents-level-1"><a class="section table-of-contents-link" href="#Time-interval-to-check-hadoop-job-status"><span class="section table-of-contents-text">Time interval to check hadoop job status</span></a></li><li class="section table-of-contents-item section table-of-contents-level-1"><a class="section table-of-contents-link" href="#Hive-database-name-for-putting-the-intermediate-flat-tables"><span class="section table-of-contents-text">Hive database name for putting the intermediate flat tables</span></a></li><li class="section table-of-contents-item section table-of-contents-level-1"><a class="section table-of-contents-link" href="#The-cut-size-for-hbase-region-in-GB"><span class="section table-of-contents-text">The cut size for hbase region, in GB.</span></a></li><li class="section table-of-contents-item section table-of-contents-level-1"><a class="section table-of-contents-link" href="#E-g-for-cube-whose-capacity-be-marked-as-“SMALL”-split-region-per-10GB-by-default"><span class="section table-of-contents-text">E.g, for cube whose capacity be marked as “SMALL”, split region per 10GB by default</span></a></li><li class="section table-of-contents-item section table-of-contents-level-1"><a class="section table-of-contents-link" href="#HBase-min-and-max-region-count"><span class="section table-of-contents-text">HBase min and max region count</span></a><ol class="section table-of-contents-child"><li class="section table-of-contents-item section table-of-contents-level-2"><a class="section table-of-contents-link" href="#Config-for-Restful-APP"><span class="section table-of-contents-text">Config for Restful APP</span></a></li></ol></li><li class="section table-of-contents-item section table-of-contents-level-1"><a class="section table-of-contents-link" href="#database-connection-settings"><span class="section table-of-contents-text">database connection settings:</span></a><ol class="section table-of-contents-child"><li class="section table-of-contents-item section table-of-contents-level-2"><a class="section table-of-contents-link" href="#Config-for-mail-service"><span class="section table-of-contents-text">Config for mail service</span></a></li></ol></li><li class="section table-of-contents-item section table-of-contents-level-1"><a class="section table-of-contents-link" href="#If-true-will-send-email-notification"><span class="section table-of-contents-text">If true, will send email notification;</span></a></li><li class="section table-of-contents-item section table-of-contents-level-1"><a class="section table-of-contents-link" href="#hive-jdbc-url"><span class="section table-of-contents-text">hive jdbc url</span></a></li></ol>
</div>


            <div class="entry red-link-context">
                <p>我原来的博文地址：<a href="https://my.oschina.net/u/1456911/blog/737144" target="_blank" rel="external">https://my.oschina.net/u/1456911/blog/737144</a><br>上传安装包</p>
<p>使用ftp工具将安装包上传至服务器的/usr/local路径</p>
<a id="more"></a>
<p>解压</p>
<p>$tar –xvf apache-kylin-1.3-HBase-1.1-SNAPSHOT-bin.tar</p>
<p>设置环境变量</p>
<p>在/etc/profile 文件添加以下内容:</p>
<p>export KYLIN_HOME=/usr/local/apache-kylin-1.3-HBase-1.1-SNAPSHOT-bin</p>
<p>export HCAT_HOME=/usr/hdp/2.3.2.0-2950/hive-hcatalog</p>
<p>之后执行source</p>
<p>$source /etc/profile</p>
<p>配置</p>
<p>进入/usr/local/apache-kylin-1.3-HBase-1.1-SNAPSHOT-bin/conf目录，编辑kylin.properties</p>
<p>需要修改和添加参数解释：</p>
<p>参数</p>
<p>格式</p>
<p>含义</p>
<p>kylin.rest.servers</p>
<p>Hostname:7070</p>
<p>Hostname为kylin server 服务器ip</p>
<p>7070为kylin http端口</p>
<p>kylin.metadata.url</p>
<p>kylin_metadata@hbase</p>
<p>kylin_metadata为kylin在hbase中建的hbase系统库名</p>
<p>kylin.storage.url</p>
<p>hbase</p>
<p>默认参数</p>
<p>kylin.hdfs.working.dir</p>
<p>/kylin</p>
<p>kylin在hdfs上的工作目录，安装时候需要在hdfs创建这个参数值的目录，并且赋予可以kylin运行的读写权限</p>
<p>kylin.hbase.cluster.fs</p>
<p>hdfs://mycluster/apps/hbase/data_new</p>
<p>hbase在数据库目录，具体值和hbase的配置文件的中的hbase.rootdir参数值相同</p>
<p>kylin.route.hive.enabled</p>
<p>true</p>
<p>默认</p>
<p>kylin.route.hive.url</p>
<p>jdbc:hive2:// HiveServer2ip:10000</p>
<p>Hiveserver2ip为hive的server组件安装ip，1000位默认的jdbc端口</p>
<p>剩余参数不需要修改，直接默认</p>
<p>启动kylin</p>
<p>$cd /usr/local/apache-kylin-1.3-HBase-1.1-SNAPSHOT-bin/bin</p>
<p>$./kylin.sh start</p>
<p>检查是否启动成功</p>
<p>查看7070端口是否监听</p>
<p>netstat –an 7070</p>
<p>直接登录<a href="http://kylinserverip:7070/kylin" target="_blank" rel="external">http://kylinserverip:7070/kylin</a></p>
<p>===============================================================</p>
<p>放一份系统的kylin配置文件</p>
<p>#</p>
<h1 id="Licensed-to-the-Apache-Software-Foundation-ASF-under-one-or-more"><a href="#Licensed-to-the-Apache-Software-Foundation-ASF-under-one-or-more" class="headerlink" title="Licensed to the Apache Software Foundation (ASF) under one or more"></a>Licensed to the Apache Software Foundation (ASF) under one or more</h1><h1 id="contributor-license-agreements-See-the-NOTICE-file-distributed-with"><a href="#contributor-license-agreements-See-the-NOTICE-file-distributed-with" class="headerlink" title="contributor license agreements.  See the NOTICE file distributed with"></a>contributor license agreements.  See the NOTICE file distributed with</h1><h1 id="this-work-for-additional-information-regarding-copyright-ownership"><a href="#this-work-for-additional-information-regarding-copyright-ownership" class="headerlink" title="this work for additional information regarding copyright ownership."></a>this work for additional information regarding copyright ownership.</h1><h1 id="The-ASF-licenses-this-file-to-You-under-the-Apache-License-Version-2-0"><a href="#The-ASF-licenses-this-file-to-You-under-the-Apache-License-Version-2-0" class="headerlink" title="The ASF licenses this file to You under the Apache License, Version 2.0"></a>The ASF licenses this file to You under the Apache License, Version 2.0</h1><h1 id="the-“License”-you-may-not-use-this-file-except-in-compliance-with"><a href="#the-“License”-you-may-not-use-this-file-except-in-compliance-with" class="headerlink" title="(the “License”); you may not use this file except in compliance with"></a>(the “License”); you may not use this file except in compliance with</h1><h1 id="the-License-You-may-obtain-a-copy-of-the-License-at"><a href="#the-License-You-may-obtain-a-copy-of-the-License-at" class="headerlink" title="the License.  You may obtain a copy of the License at"></a>the License.  You may obtain a copy of the License at</h1><p>#</p>
<h1 id="http-www-apache-org-licenses-LICENSE-2-0"><a href="#http-www-apache-org-licenses-LICENSE-2-0" class="headerlink" title="http://www.apache.org/licenses/LICENSE-2.0"></a><a href="http://www.apache.org/licenses/LICENSE-2.0" target="_blank" rel="external">http://www.apache.org/licenses/LICENSE-2.0</a></h1><p>#</p>
<h1 id="Unless-required-by-applicable-law-or-agreed-to-in-writing-software"><a href="#Unless-required-by-applicable-law-or-agreed-to-in-writing-software" class="headerlink" title="Unless required by applicable law or agreed to in writing, software"></a>Unless required by applicable law or agreed to in writing, software</h1><h1 id="distributed-under-the-License-is-distributed-on-an-“AS-IS”-BASIS"><a href="#distributed-under-the-License-is-distributed-on-an-“AS-IS”-BASIS" class="headerlink" title="distributed under the License is distributed on an “AS IS” BASIS,"></a>distributed under the License is distributed on an “AS IS” BASIS,</h1><h1 id="WITHOUT-WARRANTIES-OR-CONDITIONS-OF-ANY-KIND-either-express-or-implied"><a href="#WITHOUT-WARRANTIES-OR-CONDITIONS-OF-ANY-KIND-either-express-or-implied" class="headerlink" title="WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied."></a>WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.</h1><h1 id="See-the-License-for-the-specific-language-governing-permissions-and"><a href="#See-the-License-for-the-specific-language-governing-permissions-and" class="headerlink" title="See the License for the specific language governing permissions and"></a>See the License for the specific language governing permissions and</h1><h1 id="limitations-under-the-License"><a href="#limitations-under-the-License" class="headerlink" title="limitations under the License."></a>limitations under the License.</h1><p>#</p>
<h2 id="Config-for-Kylin-Engine"><a href="#Config-for-Kylin-Engine" class="headerlink" title="Config for Kylin Engine"></a>Config for Kylin Engine</h2><h1 id="List-of-web-servers-in-use-this-enables-one-web-server-instance-to-sync-up-with-other-servers"><a href="#List-of-web-servers-in-use-this-enables-one-web-server-instance-to-sync-up-with-other-servers" class="headerlink" title="List of web servers in use, this enables one web server instance to sync up with other servers."></a>List of web servers in use, this enables one web server instance to sync up with other servers.</h1><p>kylin.rest.servers=hadoop00:7070,hadoop01:7070,hadoop02:7070,hadoop04:7070,hadoop05:7070</p>
<p>#set display timezone on UI,format like[GMT+N or GMT-N]<br>kylin.rest.timezone=GMT+8<br>kylin.query.cache.enabled=true</p>
<h1 id="The-metadata-store-in-hbase"><a href="#The-metadata-store-in-hbase" class="headerlink" title="The metadata store in hbase"></a>The metadata store in hbase</h1><p>kylin.metadata.url=kylin_metadata@hbase</p>
<h1 id="The-storage-for-final-cube-file-in-hbase"><a href="#The-storage-for-final-cube-file-in-hbase" class="headerlink" title="The storage for final cube file in hbase"></a>The storage for final cube file in hbase</h1><p>kylin.storage.url=hbase<br>kylin.job.yarn.app.rest.check.status.url=<a href="http://hadoop02:8088/ws/v1/cluster/apps/${job_id}?" target="_blank" rel="external">http://hadoop02:8088/ws/v1/cluster/apps/${job_id}?</a><br>kylin.job.yarn.app.rest.check.interval.seconds=20<br>kylin.query.security.enabled=false</p>
<h1 id="Temp-folder-in-hdfs-make-sure-user-has-the-right-access-to-the-hdfs-directory"><a href="#Temp-folder-in-hdfs-make-sure-user-has-the-right-access-to-the-hdfs-directory" class="headerlink" title="Temp folder in hdfs, make sure user has the right access to the hdfs directory"></a>Temp folder in hdfs, make sure user has the right access to the hdfs directory</h1><p>kylin.hdfs.working.dir=/kylin</p>
<h1 id="HBase-Cluster-FileSystem-which-serving-hbase-format-as-hdfs-hbase-cluster-8020"><a href="#HBase-Cluster-FileSystem-which-serving-hbase-format-as-hdfs-hbase-cluster-8020" class="headerlink" title="HBase Cluster FileSystem, which serving hbase, format as hdfs://hbase-cluster:8020"></a>HBase Cluster FileSystem, which serving hbase, format as hdfs://hbase-cluster:8020</h1><h1 id="leave-empty-if-hbase-running-on-same-cluster-with-hive-and-mapreduce"><a href="#leave-empty-if-hbase-running-on-same-cluster-with-hive-and-mapreduce" class="headerlink" title="leave empty if hbase running on same cluster with hive and mapreduce"></a>leave empty if hbase running on same cluster with hive and mapreduce</h1><p>kylin.hbase.cluster.fs=hdfs://mycluster/apps/hbase/data<br>kylin.route.hive.enabled=true<br>kylin.route.hive.url=jdbc:hive2://hadoop00:10000</p>
<p>kylin.job.mapreduce.default.reduce.input.mb=500</p>
<p>kylin.server.mode=all</p>
<h1 id="If-true-job-engine-will-not-assume-that-hadoop-CLI-reside-on-the-same-server-as-it-self"><a href="#If-true-job-engine-will-not-assume-that-hadoop-CLI-reside-on-the-same-server-as-it-self" class="headerlink" title="If true, job engine will not assume that hadoop CLI reside on the same server as it self"></a>If true, job engine will not assume that hadoop CLI reside on the same server as it self</h1><h1 id="you-will-have-to-specify-kylin-job-remote-cli-hostname-kylin-job-remote-cli-username-and-kylin-job-remote-cli-password"><a href="#you-will-have-to-specify-kylin-job-remote-cli-hostname-kylin-job-remote-cli-username-and-kylin-job-remote-cli-password" class="headerlink" title="you will have to specify kylin.job.remote.cli.hostname, kylin.job.remote.cli.username and kylin.job.remote.cli.password"></a>you will have to specify kylin.job.remote.cli.hostname, kylin.job.remote.cli.username and kylin.job.remote.cli.password</h1><h1 id="It-should-not-be-set-to-“true”-unless-you’re-NOT-running-Kylin-sh-on-a-hadoop-client-machine"><a href="#It-should-not-be-set-to-“true”-unless-you’re-NOT-running-Kylin-sh-on-a-hadoop-client-machine" class="headerlink" title="It should not be set to “true” unless you’re NOT running Kylin.sh on a hadoop client machine"></a>It should not be set to “true” unless you’re NOT running Kylin.sh on a hadoop client machine</h1><h1 id="Thus-kylin-instance-has-to-ssh-to-another-real-hadoop-client-machine-to-execute-hbase-hive-hadoop-commands"><a href="#Thus-kylin-instance-has-to-ssh-to-another-real-hadoop-client-machine-to-execute-hbase-hive-hadoop-commands" class="headerlink" title="(Thus kylin instance has to ssh to another real hadoop client machine to execute hbase,hive,hadoop commands)"></a>(Thus kylin instance has to ssh to another real hadoop client machine to execute hbase,hive,hadoop commands)</h1><p>kylin.job.run.as.remote.cmd=false</p>
<h1 id="Only-necessary-when-kylin-job-run-as-remote-cmd-true"><a href="#Only-necessary-when-kylin-job-run-as-remote-cmd-true" class="headerlink" title="Only necessary when kylin.job.run.as.remote.cmd=true"></a>Only necessary when kylin.job.run.as.remote.cmd=true</h1><p>kylin.job.remote.cli.hostname=</p>
<h1 id="Only-necessary-when-kylin-job-run-as-remote-cmd-true-1"><a href="#Only-necessary-when-kylin-job-run-as-remote-cmd-true-1" class="headerlink" title="Only necessary when kylin.job.run.as.remote.cmd=true"></a>Only necessary when kylin.job.run.as.remote.cmd=true</h1><p>kylin.job.remote.cli.username=</p>
<h1 id="Only-necessary-when-kylin-job-run-as-remote-cmd-true-2"><a href="#Only-necessary-when-kylin-job-run-as-remote-cmd-true-2" class="headerlink" title="Only necessary when kylin.job.run.as.remote.cmd=true"></a>Only necessary when kylin.job.run.as.remote.cmd=true</h1><p>kylin.job.remote.cli.password=</p>
<h1 id="Used-by-test-cases-to-prepare-synthetic-data-for-sample-cube"><a href="#Used-by-test-cases-to-prepare-synthetic-data-for-sample-cube" class="headerlink" title="Used by test cases to prepare synthetic data for sample cube"></a>Used by test cases to prepare synthetic data for sample cube</h1><p>kylin.job.remote.cli.working.dir=/tmp/kylin</p>
<h1 id="Max-count-of-concurrent-jobs-running"><a href="#Max-count-of-concurrent-jobs-running" class="headerlink" title="Max count of concurrent jobs running"></a>Max count of concurrent jobs running</h1><p>kylin.job.concurrent.max.limit=10</p>
<h1 id="Time-interval-to-check-hadoop-job-status"><a href="#Time-interval-to-check-hadoop-job-status" class="headerlink" title="Time interval to check hadoop job status"></a>Time interval to check hadoop job status</h1><p>kylin.job.yarn.app.rest.check.interval.seconds=10</p>
<h1 id="Hive-database-name-for-putting-the-intermediate-flat-tables"><a href="#Hive-database-name-for-putting-the-intermediate-flat-tables" class="headerlink" title="Hive database name for putting the intermediate flat tables"></a>Hive database name for putting the intermediate flat tables</h1><p>kylin.job.hive.database.for.intermediatetable=kylin</p>
<p>#default compression codec for htable,snappy,lzo,gzip,lz4</p>
<p>#kylin.hbase.default.compression.codec=lzo</p>
<h1 id="The-cut-size-for-hbase-region-in-GB"><a href="#The-cut-size-for-hbase-region-in-GB" class="headerlink" title="The cut size for hbase region, in GB."></a>The cut size for hbase region, in GB.</h1><h1 id="E-g-for-cube-whose-capacity-be-marked-as-“SMALL”-split-region-per-10GB-by-default"><a href="#E-g-for-cube-whose-capacity-be-marked-as-“SMALL”-split-region-per-10GB-by-default" class="headerlink" title="E.g, for cube whose capacity be marked as “SMALL”, split region per 10GB by default"></a>E.g, for cube whose capacity be marked as “SMALL”, split region per 10GB by default</h1><p>kylin.hbase.region.cut.small=10<br>kylin.hbase.region.cut.medium=20<br>kylin.hbase.region.cut.large=100</p>
<h1 id="HBase-min-and-max-region-count"><a href="#HBase-min-and-max-region-count" class="headerlink" title="HBase min and max region count"></a>HBase min and max region count</h1><p>kylin.hbase.region.count.min=1<br>kylin.hbase.region.count.max=500</p>
<h2 id="Config-for-Restful-APP"><a href="#Config-for-Restful-APP" class="headerlink" title="Config for Restful APP"></a>Config for Restful APP</h2><h1 id="database-connection-settings"><a href="#database-connection-settings" class="headerlink" title="database connection settings:"></a>database connection settings:</h1><p>ldap.server=<br>ldap.username=<br>ldap.password=<br>ldap.user.searchBase=<br>ldap.user.searchPattern=<br>ldap.user.groupSearchBase=<br>ldap.service.searchBase=OU=<br>ldap.service.searchPattern=<br>ldap.service.groupSearchBase=<br>acl.adminRole=<br>acl.defaultRole=<br>ganglia.group=<br>ganglia.port=8664</p>
<h2 id="Config-for-mail-service"><a href="#Config-for-mail-service" class="headerlink" title="Config for mail service"></a>Config for mail service</h2><h1 id="If-true-will-send-email-notification"><a href="#If-true-will-send-email-notification" class="headerlink" title="If true, will send email notification;"></a>If true, will send email notification;</h1><p>mail.enabled=false<br>mail.host=<br>mail.username=<br>mail.password=<br>mail.sender=</p>
<p>###########################config info for web#######################</p>
<p>#help info ,format{name|displayName|link} ,optional<br>kylin.web.help.length=4<br>kylin.web.help.0=start|Getting Started|<br>kylin.web.help.1=odbc|ODBC Driver|<br>kylin.web.help.2=tableau|Tableau Guide|<br>kylin.web.help.3=onboard|Cube Design Tutorial|</p>
<p>#hadoop url link ,optional<br>kylin.web.hadoop=</p>
<p>#job diagnostic url link ,optional<br>kylin.web.diagnostic=</p>
<p>#contact mail on web page ,optional<br>kylin.web.contact_mail=</p>
<p>###########################config info for front#######################</p>
<p>#env DEV|QA|PROD<br>deploy.env=PROD</p>
<p>###########################config info for sandbox#######################<br>kylin.sandbox=true</p>
<p>###########################config info for kylin monitor#######################</p>
<h1 id="hive-jdbc-url"><a href="#hive-jdbc-url" class="headerlink" title="hive jdbc url"></a>hive jdbc url</h1><p>kylin.monitor.hive.jdbc.connection.url=jdbc:hive2://hadoop00:10000</p>
<p>#config where to parse query log,split with comma ,will also read $KYLIN_HOME/tomcat/logs/ by default<br>kylin.monitor.ext.log.base.dir = /tmp/kylin_log1,/tmp/kylin_log2</p>
<p>#will create external hive table to query result csv file</p>
<p>#will set to kylin_query_log by default if not config here<br>kylin.monitor.query.log.parse.result.table = kylin_query_log</p>

                
<p class="red-link-context">
    <a href="/2017/07/06/MySql5.7绿色版安装教程（附密码过期解决方法）/" rel="next" title="MySql5.7绿色版安装教程（附密码过期解决方法）">
    上一篇：MySql5.7绿色版安装教程（附密码过期解决方法）
  </a>
</p>



<p class="red-link-context">
    <a href="/2017/04/13/Nginx安装/" rel="next" title="Nginx安装">
    下一篇：Nginx安装
  </a>
</p>


            </div>
			
        </div>
    </div>
</article>




    <section id="comment">
        <div class="card">
            <div class="card-content">
                <!-- Duoshuo Comment BEGIN -->
                <div class="ds-thread" data-thread-key="2017/07/06/Apache Kylin安装/" data-title="Apache Kylin安装" data-url="http://dengzy007hi.oschina.io/2017/07/06/Apache Kylin安装/"></div>

                <script type="text/javascript">
                    console.log(document.querySelector('.ds-thread'));
                    var duoshuoQuery = {
                        short_name: 'dengzy007hi'
                    };
                    (function() {
                        var ds = document.createElement('script');
                        ds.type = 'text/javascript';
                        ds.async = true;
                        ds.src = (document.location.protocol == 'https:'
                            ? 'https:'
                            : 'http:') + '//static.duoshuo.com/embed.js';
                        ds.charset = 'UTF-8';
                        (document.getElementsByTagName('head')[0] || document.getElementsByTagName('body')[0]).appendChild(ds);
                    })();
                </script>
                <!-- Duoshuo Comment END -->
            </div>
        </div>
    </section>



</div>

        <div class="fixed-action-btn float-sitemap">
    <a class="btn-floating btn-large red">
      <i class="fa fa-caret-square-o-up"></i>
    </a>
    <ul>
      <li><a class="btn-return-top btn-floating waves-effect cyan" title="回到顶部"><i class="fa fa-arrow-circle-o-up"></i></a></li>
      <li><a class="btn-floating waves-effect button-collapse light-green"  data-activates="main-menu" title="menu"><i class="fa fa-navicon"></i></a></li>
    </ul>
  </div>

    </main>
    <footer class="page-footer green darken-1">
    
    <div class="container">
        <div class="row">
            
            <div class="social-group col m4 s12">
                <h5 class="white-text">社交</h5>
                
                    <a class="social-link" href="http://weibo.com/bambooJN" target="_blank">
                        <i class="fa fa-2x fa-weibo"></i>
                    </a>
                
                    <a class="social-link" href="https://git.oschina.net/dengzy007hi" target="_blank">
                        <i class="fa fa-2x fa-github"></i>
                    </a>
                
                    <a class="social-link" href="/atom.xml" target="_blank">
                        <i class="fa fa-2x fa-rss"></i>
                    </a>
                
                <div class="site-visitors-container white-text">
                    <span>
                        <i class="fa fa-user"></i>
                        <span class="busuanzi-value" id="busuanzi_value_site_uv"></span>
                    </span>
                    <span>&nbsp;|&nbsp;</span>
                    <span>
                        <i class="fa fa-eye"></i>
                        <span class="busuanzi-value" id="busuanzi_value_site_pv"></span>
                    </span>
                </div>
            </div>
            

            
            <div class="col m8 s12">
                <h5 class="white-text">友情链接</h5>
                
                    <a class="social-link" href="https://www.oschina.net" target="_blank">开源中国</a>
                
                    <a class="social-link" href="http://jdkleo.iteye.com/" target="_blank">JDKLEO</a>
                
                    <a class="social-link" href="http://pkaq.org/" target="_blank">如是我闻</a>
                
            </div>
            
        </div>
    </div>
    

    <div class="footer-copyright red-link-context">
        <div class="container">
            © 2017 dzy20@qq.com, All rights reserved.
            <p class="right" style="margin-top: 0;">本博客由 <a href="https://hexo.io">Hexo</a> 强力驱动 | 主题 <a href="https://github.com/raytaylorlin/hexo-theme-raytaylorism">raytaylorism</a></p>
        </div>
    </div>
</footer>


    <noscript>
    <div class="noscript">
        <p class="center-align">当前网速较慢或者你使用的浏览器不支持博客特定功能，请尝试刷新或换用Chrome、Firefox等现代浏览器</p>
    </div>
</noscript>
<div class="noscript">
    <p class="center-align">当前网速较慢或者你使用的浏览器不支持博客特定功能，请尝试刷新或换用Chrome、Firefox等现代浏览器</p>
</div>


<script src="/js/jquery.min.js"></script>
<script src="/js/materialize.min.js"></script>
<script async src="//dn-lbstatics.qbox.me/busuanzi/2.3/busuanzi.pure.mini.js">
</script>

<script>
    (function($) {
        $(document).ready(function() {
            // 隐藏禁用javascript（针对微信内置浏览器）的提示
            $('.noscript').hide();

            // 图片缩放效果
            var $imgs = $('img').not('.slider-image').not('.avatar-image').not('.carousel-image').not('.card-cover-image').not('.qrcode');

            // 给图片加上点击放大效果（materialbox插件）
            $imgs.addClass('materialboxed').each(function(i, el) {
                $(this).attr('data-caption', $(this).attr('alt') || ' ');
            }).materialbox();

            // 优化表格的显示
            $('table').each(function() {
                var $table = $(this);
                // 除去多行代码的情况
                if ($table.find('pre').length == 0) {
                    $table.addClass('responsive-table striped bordered');
                }
            });

            // 首页幻灯片
            $('.slider').slider({indicators: true, full_width: true, interval: 8000});

            $(".button-collapse").sideNav();
            $(".category-menu").sideNav();

            // 针对gallery post
            $('.carousel').carousel({full_width: true});
            $('.carousel-control.prev').click(function() {
                $('.carousel').carousel('prev');
            });
            $('.carousel-control.next').click(function() {
                $('.carousel').carousel('next');
            });

            // 文章目录
            $('article').not('.simple-article').find('h1').add('h2').add('h3').add('h4').add('h5').add('h6').scrollSpy();

            // 目录随屏幕滚动（防止目录过长越过footer）
            var $toc = $('.toc');
            var scrollTargetTop = 0;
            $(window).scroll(function() {
                var $activeLink = $toc.find('a.active.section');
                if ($(window).scrollTop() < 100) {
                    scrollTargetTop = 0;
                } else {
                    if ($activeLink[0]) {
                        scrollTargetTop = $activeLink.offset().top - $toc.offset().top;
                    }
                }
                $toc.css('top', '-' + scrollTargetTop + 'px');
            });

            // 修正文章目录的left-border颜色
            var color = $('.table-of-contents-text').css('color');
            $('.table-of-contents-link').css('border-left-color', color);

            // 针对移动端做的优化：FAB按钮点击一下收回
            if (/Android|webOS|iPhone|iPad|iPod|BlackBerry|IEMobile|Opera Mini/i.test(navigator.userAgent)) {
                $('.fixed-action-btn').addClass('click-to-toggle');
            }
            // 回到顶部
            $('.btn-return-top').click(function() {
                $('body, html').animate({
                    scrollTop: 0
                }, 500);
            });

            // 重置读书页面的Tab标签页的颜色
            $('li.tab a').hover(function() {
                $(this).toggleClass('text-lighten-4');
            });
            $('.indicator').addClass('red lighten-2');

            
            // 添加new标签
            $('.menu-about').append('<span class="new badge red"></span>');
            

            // 搜索功能
            $('.modal-trigger').leanModal({
                // 打开搜索框时自动聚焦
                ready: function() {
                    if ($('#search').is(":visible")) {
                        $('#search-input').focus();
                    }
                }
            });
            var searchXml = "search.xml";
            if (searchXml.length == 0) {
             	searchXml = "search.xml";
            }
            var searchPath = "/" + searchXml;
            initSearch(searchPath, 'search-input', 'search-result');
        });

        // 初始化搜索与匹配函数
        var initSearch = function(path, search_id, content_id) {
            'use strict';
            $.ajax({
                url: path,
                dataType: "xml",
                success: function(xmlResponse) {
                    // get the contents from search data
                    var datas = $("entry", xmlResponse).map(function() {
                        return {
                            title: $("title", this).text(),
                            content: $("content", this).text(),
                            url: $("url", this).text()
                        };
                    }).get();
                    var $input = document.getElementById(search_id);
                    var $resultContent = document.getElementById(content_id);
                    $input.addEventListener('input', function() {
                        var str = '<ul class=\"search-result-list\">';
                        var keywords = this.value.trim().toLowerCase().split(/[\s\-]+/);
                        $resultContent.innerHTML = "";
                        if (this.value.trim().length <= 0) {
                            return;
                        }
                        // perform local searching
                        datas.forEach(function(data) {
                            var isMatch = true;
                            var content_index = [];
                            var data_title = data.title.trim().toLowerCase();
                            var data_content = data.content.trim().replace(/<[^>]+>/g, "").toLowerCase();
                            var data_url = data.url;
                            var index_title = -1;
                            var index_content = -1;
                            var first_occur = -1;
                            // only match artiles with not empty titles and contents
                            if (data_title != '' && data_content != '') {
                                keywords.forEach(function(keyword, i) {
                                    index_title = data_title.indexOf(keyword);
                                    index_content = data_content.indexOf(keyword);
                                    if (index_title < 0 && index_content < 0) {
                                        isMatch = false;
                                    } else {
                                        if (index_content < 0) {
                                            index_content = 0;
                                        }
                                        if (i == 0) {
                                            first_occur = index_content;
                                        }
                                    }
                                });
                            }
                            // show search results
                            if (isMatch) {
                                keywords.forEach(function(keyword) {
                                    var regS = new RegExp(keyword, "gi");
                                    data_title = data_title.replace(regS, "<span class=\"search-keyword red lighten-2\">" + keyword + "</span>");
                                });

                                str += "<li><a href='" + data_url + "' class='search-result-title'>" + data_title + "</a>";
                                var content = data.content.trim().replace(/<[^>]+>/g, "");
                                if (first_occur >= 0) {
                                    // cut out 100 characters
                                    var start = first_occur - 20;
                                    var end = first_occur + 80;
                                    if (start < 0) {
                                        start = 0;
                                    }
                                    if (start == 0) {
                                        end = 100;
                                    }
                                    if (end > content.length) {
                                        end = content.length;
                                    }
                                    var match_content = content.substring(start, end);
                                    // highlight all keywords
                                    keywords.forEach(function(keyword) {
                                        var regS = new RegExp(keyword, "gi");
                                        match_content = match_content.replace(regS, "<span class=\"search-keyword red lighten-2\">" + keyword + "</span>");
                                    });

                                    str += "<p class=\"search-result\">..." + match_content + "...</p>"
                                }
                                str += "</li>";
                            }
                        });
                        str += "</ul>";
                        $resultContent.innerHTML = str;
                    });
                }
            });
        }
    })(jQuery);
</script>


<script src="/js/prettify.js"></script>
<script type="text/javascript">
    $(document).ready(function() {
        $("pre").addClass("prettyprint");
        prettyPrint();
    });
</script>








</body>
</html>
